Selecting cells using the keyboard

Alternatively, you can use the keyboard to highlight several consecutive cells, rows or columns.

  • ►  In the matrix, select one or more cells, rows, or columns.

Hotkeys

Description

Shift + arrow keys

Press the Shift key and the appropriate arrow key simultaneously to extend the currently selected section towards the particular direction, or reduce it, as applicable.

Shift + Pos1

Press Shift + Pos1 to select all cells to the left of the selected cells.

Shift + End

Press Shift + End to select all cells to the right of the selected cells.

Shift + Pup

Press Shift + Pup to select all cells above the selected cells.

Shift + Pdn

Press Shift + Pdown to select all cells below the selected cells.

Ctrl + A

Press Ctrl + A to select all cells.